DataMaintenanceEvent

Entity Definition

Logical Name : DataMaintenanceEvent
Physical Name : CO_EV_MNT

A type of EVENT which represents a collection of changes to configuration data stored in the database. These changes may reflect a promotional activity, a set of price changes, item additions and deletions, or general maintenance of data.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EventID (FK)(PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer
OperatorID (FK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
CompetitorID (FK) The unique identifier assigned to a competitor by the store. ID_CMP Identity integer Competitor(PA_CMP)
ReasonCode Establishes a reason for the maintenance event. Reason codes will be determined by each retailer. RC_EV_MNT Code4 char(4)
TypeCode Categorizes the maintenance event based on its intended purpose and subject. Examples include ITEM maintenance, selling rules maintenance, tender authorization maintenance and a whole host of different aspects of the retail store data model that may be maintained from the home office. TY_EV_MNT Code2 char(2)
AppliedTimestamp The date and time the maintenance event's associated adds, changes and deletes are applied to the store database. TS_EV_MNT_APLY AuditDateTime datetime
CreateDateTimestamp The date and time this maintenance event was created. TS_EV_MNT_CRT AuditDateTime datetime
OriginTypeCode The origin for this maintenance event. Examples of origins include: home office, store, etc. TY_EV_MNT_ORG Code4 char(4)

Relationships

Parent Entity Verb Phrase Child Entity
Competitor instigates DataMaintenanceEvent
Operator creates DataMaintenanceEvent
ScheduledEvent can be a DataMaintenanceEvent
DataMaintenanceEvent can be a ItemMaintenanceEvent
DataMaintenanceEvent can be a TaxMaintenanceEvent
DataMaintenanceEvent can be a RewardEligibilityRuleMaintenance
DataMaintenanceEvent can be a Z_PriceDerivationRuleMaintenance

Logical Views containing DataMaintenanceEvent

Logical View
Logical 01300 - Item Price Maintenance View
Logical 05000 - Taxation - Macro View
Logical 06700 - Event Scheduler View
Logical 11100 - Worker - Macro View